---
title: DB-CLL-025 — Retrieve the outcome issue list for an outcome
summary: Retrieve the outcome issue list for an outcome
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-025 — Retrieve the outcome issue list for an outcome

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-025 |
| Operation type | R |
| Execution method | Text |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Inline text SQL |
| Business object | clsOutcomeIssue collection ctor |
| Criteria property | MyRetrieveSQL |
| Lifecycle method | BeforeRetrieve |

## Parameters

| Name | Direction | Type | Default | Description |
|---|---|---|---|---|
| CaseOutcomeID | Input | NUMBER | N/A | Case outcome identifier used to filter issue rows |

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [OUTCOME_ISSUE](../database-tables.md#outcome_issue) | SELECT | CASE_OUTCOME_SEQ_NUM, all OUTCOME_ISSUE columns |

## Sample SQL

```sql
Select
  OUTCOME_ISSUE.OUTCOME_ISSUE_SEQ_NUM as OutcomeIssueID,
  OUTCOME_ISSUE.CASE_OUTCOME_SEQ_NUM as CaseOutcomeID,
  OUTCOME_ISSUE.OUTCOME_ISSUE_CODE as OutcomeIssueCode,
  OUTCOME_ISSUE.OUTCOME_GROUNDS_CODE as OutcomeGroundsCode,
  OUTCOME_ISSUE.NATURE_CODE as NatureCode,
  OUTCOME_ISSUE.WIN_LOSS_FLAG as WinLossFlag,
  OUTCOME_ISSUE.FEE_AMOUNT as FeeAmount,
  OUTCOME_ISSUE.PENALTY_FLAG as PenaltyFlag,
  OUTCOME_ISSUE.SUMMARY_TEXT as SummaryText,
  OUTCOME_ISSUE.PRIMARY_ISSUE_FLAG as PrimaryIssueFlag,
  OUTCOME_ISSUE.CREATE_DATE as CreateDate,
  OUTCOME_ISSUE.CREATE_USER as CreateUser,
  OUTCOME_ISSUE.UPDATE_DATE as UpdateDate,
  OUTCOME_ISSUE.UPDATE_USER as UpdateUser,
  OUTCOME_ISSUE.LEGAL_BODY_PART_CODE as LegalBodyPartCode
From
  OUTCOME_ISSUE
Where
  OUTCOME_ISSUE.CASE_OUTCOME_SEQ_NUM = :CaseOutcomeID
```

## Operations and processes

- [Manage case outcomes, issues, and staff](../operations/manage-case-outcome.md)

## Business rules

- [BR-CLM-LGL-005](../business-rules.md#br-clm-lgl-005-non-single-row-crud-result-is-treated-as-a-failure)

## Sources

- `SAIF.Business.Claim.Legal\LegalNet\clsOutcomeIssue.vb`